/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 80020
 Source Host           : localhost:3306
 Source Schema         : db_26_cloud

 Target Server Type    : MySQL
 Target Server Version : 80020
 File Encoding         : 65001

 Date: 12/10/2020 16:25:06
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tab_directory
-- ----------------------------
DROP TABLE IF EXISTS `tab_directory`;
CREATE TABLE `tab_directory` (
  `did` int NOT NULL AUTO_INCREMENT COMMENT '编号',
  `dname` varchar(20) DEFAULT NULL COMMENT '用户名',
  `dfu` varchar(100) DEFAULT NULL COMMENT '父文件夹：以-分割',
  `dcreate_time` datetime DEFAULT NULL COMMENT '创建时间',
  `uid` int DEFAULT NULL COMMENT '所属用户',
  `fid` int DEFAULT NULL COMMENT '文件的 id',
  `dtype` int DEFAULT NULL COMMENT '是否是文件 1是文件 0是文件夹',
  PRIMARY KEY (`did`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tab_directory
-- ----------------------------
BEGIN;
INSERT INTO `tab_directory` VALUES (1, 'image', '0', '2020-10-11 08:24:23', 1, NULL, NULL);
INSERT INTO `tab_directory` VALUES (3, 'image2', '0-1', '2020-10-11 08:24:54', 1, 2, 1);
INSERT INTO `tab_directory` VALUES (4, 'image3', '0-1', '2020-10-11 08:25:05', 1, 3, 1);
COMMIT;

-- ----------------------------
-- Table structure for tab_file
-- ----------------------------
DROP TABLE IF EXISTS `tab_file`;
CREATE TABLE `tab_file` (
  `fid` int NOT NULL AUTO_INCREMENT COMMENT '编号',
  `furl` varchar(200) DEFAULT NULL COMMENT '文件的路径',
  `fsize` int DEFAULT NULL COMMENT '文件大小',
  `fmd5` varchar(32) DEFAULT NULL COMMENT '文件的md5',
  PRIMARY KEY (`fid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tab_file
-- ----------------------------
BEGIN;
INSERT INTO `tab_file` VALUES (1, '1602422683148wallhaven-83z1qk.jpg', 5643022, '56c3dad8af6664ba7cdc97af1a0f31ab');
INSERT INTO `tab_file` VALUES (2, '1602422694262wallhaven-83z85y.jpg', 2844751, '4cb323ed3ea7e7148caa4cb06661c5fe');
INSERT INTO `tab_file` VALUES (3, '1602422705025wallhaven-96qwed.jpg', 12924169, 'c3f81a3cfce56c9bab9bf7633ace1b54');
COMMIT;

-- ----------------------------
-- Table structure for tab_user
-- ----------------------------
DROP TABLE IF EXISTS `tab_user`;
CREATE TABLE `tab_user` (
  `uid` int NOT NULL AUTO_INCREMENT COMMENT '编号',
  `uname` varchar(20) DEFAULT NULL COMMENT '用户名',
  `upwd` varchar(100) DEFAULT NULL COMMENT '密码',
  `usex` char(1) DEFAULT NULL COMMENT '性别',
  `ustatus` char(1) DEFAULT NULL COMMENT '状态：0 未登陆 1 已登陆 -1 冻结',
  `uremark` varchar(20) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tab_user
-- ----------------------------
BEGIN;
INSERT INTO `tab_user` VALUES (1, '韩梅梅', '9337b6d01baab58f4b8828326d90ac07', '女', '1', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
